Interview Questions

1. How to record package information at run time?

Options:

a. By using Logging option

b. By using Event Handling

c. All the Above

d. None of these

Reveal Answer

2. In SSIS 2012, What are the two approaches for dealing with logging are possible?

Options:

a. Legacy Deployment Model

b. Project Deployment Model

c. All the Above

d. None of the Above

Reveal Answer

3. SSIS has a default means to log all records updated, deleted or inserted on a per table basis?

Options:

a. True

b. False

Reveal Answer

4. What is Event Handler in SSIS?

Options:

a. respond to raised events in your package

b. provide ordinal relationship b/w various Items in your package

c. It provide the functionality to your package

d. None

Reveal Answer

5. As per error handling in T/R, which one handle the better performance?

Options:

a. Like fail component

b. redirect row

c. All the Above

d. None

Reveal Answer

6. Define Some Events in SSIS?

Options:

a. OnPostExecute

b. OnPreExecute

c. OnInformation

d. OnError

Reveal Answer

7. What are the different SSIS Log Providers?

Options:

a. SSIS log provider for Text files

b. SSIS log provider for Windows Event Log

c. SSIS log provider for XML files

d. SSIS log provider for SQL Profiler

Reveal Answer

8. Explain event handlers?

Options:

a. To handle data validations

b. To handle errors

c. To handle events

d. None

Reveal Answer

Interview Questions and Answer

1. How to record package information at run time?

2. In SSIS 2012, What are the two approaches for dealing with logging are possible?

3. SSIS has a default means to log all records updated, deleted or inserted on a per table basis?

4. What is Event Handler in SSIS?

5. As per error handling in T/R, which one handle the better performance?

6. Define Some Events in SSIS?

7. What are the different SSIS Log Providers?

8. Explain event handlers?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources